package com.zhao.util;

import com.zhao.javabean.User;
import mapper.UserMapper;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.util.Date;
import java.util.List;

public class UserTest {
    SqlSession session;
    UserMapper mapper;
    @Before//会在所有test方法执行前执行
    public void a(){
        //1、创建SqlSessionFactory对象，也是单例模式的
        SqlSessionFactory factory = MyBatisUtil.getSqlSessionFactory();
        //2、创建SqlSession对象 true 自动提交事务 不写也没事 因为默认在sqlsession关闭时提交事务
        session= factory.openSession(true);
        //3、调用session的方法namespace的名字.id
        mapper= session.getMapper(UserMapper.class);
    }
    @After//会在所有test方法执行后执行
    public void b(){
        //5、关闭资源
        session.close();
    }

    @Test
    public void selectAllUser(){
        List<User> users = mapper.selectAllUser();
        //4、打印测试
        for(User u:users){
            System.out.println(u);
        }
    }

    @Test
    public void selectById(){
        User user = mapper.selectById(2);
        System.out.println(user);
    }

    @Test
    public void selectLikeName(){
        List<User> users = mapper.selectLikeName("武松");
        //4、打印测试
        for(User u:users){
            System.out.println(u);
        }
    }

    @Test
    public void updateNameById(){
        mapper.updateNameById(1,"bbb");
    }
    @Test
    public void insert(){
        mapper.insert("add",200,new Date());
    }

    @Test
    public void insertUser(){
        User u=new User();
        u.setName("add1");
        u.setSal(300);
        u.setBirthday(new Date());
        mapper.insertUser(u);
    }

    @Test
    public void deleteByArray(){
        int[] ids={12,13};
        mapper.deleteByArray(ids);
    }

}